UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LnLe5Rq17g2HCZQySycEdnmCCFt9987z1sOQRy63HsM='
WHERE
key_id = 'f2d5010c70ef58125ca43ae048951cb75ad5b4d1cad0823ad84bf1a1a901ba9f'
AND (
token = 'LnLe5Rq17g2HCZQySycEdnmCCFt9987z1sOQRy63HsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)