UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0+2I2nzIycrtfMOruWwHk/ZBJ0np5Kq9bHwZWDnKU8s='
WHERE
key_id = '52ddaf06a881508b82067350d23510b9cfd8e5caca64f3223c04dbd65e370eed'
AND (
token = '0+2I2nzIycrtfMOruWwHk/ZBJ0np5Kq9bHwZWDnKU8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)