UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XY87bLPcZRpYVTEHcX1tVqmnVIuV/cBolaQe5WgqLPA='
WHERE
key_id = 'ecf1d84680037c63083b17981c30f33b9a8a8667b62f2cd3161bb337a02dcb9f'
AND (
token = 'XY87bLPcZRpYVTEHcX1tVqmnVIuV/cBolaQe5WgqLPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)