UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cISHovbtj5Fz31OousMGe1zdzJIgDyuQaZRN+S5xwWA='
WHERE
key_id = '3995b9c5015682f435b3bb7a322d9fbc874167c080ef7498aaf1af4ea1cdbc40'
AND (
token = 'cISHovbtj5Fz31OousMGe1zdzJIgDyuQaZRN+S5xwWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)