UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D5ZEBg6GxQrb5eoRNs1ISmmYIBkAshbQwxRwG7grMvE='
WHERE
key_id = '1196e19bb02100a5feafecc0222959fe7832236b5c80096463ac1592299c532c'
AND (
token = 'D5ZEBg6GxQrb5eoRNs1ISmmYIBkAshbQwxRwG7grMvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)