UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2rPv/0OsC5i5mel9u7Cy0SYdnFJ0UdqVDbvTfb3RFxU='
WHERE
key_id = '5586f44651ca65f2120d8c2a792a64abaf1681f8822d648c27709b7f9683c078'
AND (
token = '2rPv/0OsC5i5mel9u7Cy0SYdnFJ0UdqVDbvTfb3RFxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)