UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ZOjyhgOLYVX8pxSV6grAfv88CHzXNrmF25qmqYbkBM='
WHERE
key_id = '0d5f7003f3cd1d03e226d3a117d33d571532c7f60828b789da5e0b0c5d1e40a2'
AND (
token = '0ZOjyhgOLYVX8pxSV6grAfv88CHzXNrmF25qmqYbkBM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)