UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lZl26HuhWN5l7YFNsrIWWinwHB8gz/453jG79j9s7HU='
WHERE
key_id = 'a2186a85b1b06e30a9446cd2688be200608a6ba42e005a79926e5d9c1a846509'
AND (
token = 'lZl26HuhWN5l7YFNsrIWWinwHB8gz/453jG79j9s7HU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)